Overview
Brought to you by YData
Dataset statistics
| Number of variables | 23 |
|---|---|
| Number of observations | 16383 |
| Missing cells | 103 |
| Missing cells (%) | < 0.1% |
| Duplicate rows | 1 |
| Duplicate rows (%) | < 0.1% |
| Total size in memory | 2.3 MiB |
| Average record size in memory | 149.0 B |
Variable types
| Numeric | 5 |
|---|---|
| Text | 9 |
| Categorical | 4 |
| Boolean | 5 |
| Dataset has 1 (< 0.1%) duplicate rows | Duplicates |
acbal is highly overall correlated with lcyacbal | High correlation |
branch is highly overall correlated with ccy and 3 other fields | High correlation |
ccy is highly overall correlated with branch and 3 other fields | High correlation |
ibservice is highly overall correlated with branch | High correlation |
lcyacbal is highly overall correlated with acbal | High correlation |
national is highly overall correlated with branch and 3 other fields | High correlation |
resident is highly overall correlated with ccy and 2 other fields | High correlation |
sector is highly overall correlated with branch and 3 other fields | High correlation |
national is highly imbalanced (99.1%) | Imbalance |
resident is highly imbalanced (99.0%) | Imbalance |
sector is highly imbalanced (90.9%) | Imbalance |
ccy is highly imbalanced (98.1%) | Imbalance |
ibservice is highly imbalanced (62.9%) | Imbalance |
kyc is highly imbalanced (62.3%) | Imbalance |
acbal is highly skewed (γ1 = -101.6301297) | Skewed |
lcyacbal is highly skewed (γ1 = -74.45659072) | Skewed |
acbal has 732 (4.5%) zeros | Zeros |
lcyacbal has 746 (4.6%) zeros | Zeros |
Reproduction
| Analysis started | 2025-01-21 06:34:08.688093 |
|---|---|
| Analysis finished | 2025-01-21 06:34:10.723866 |
| Duration | 2.04 seconds |
| Software version | ydata-profiling vv4.12.2 |
| Download configuration | config.json |
Variables
custid
Real number (ℝ)
| Distinct | 15482 |
|---|---|
| Distinct (%) | 94.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 283508.88 |
| Minimum | 44 |
|---|---|
| Maximum | 999998 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 128.1 KiB |
Quantile statistics
| Minimum | 44 |
|---|---|
| 5-th percentile | 8541.5 |
| Q1 | 63772.5 |
| median | 242074 |
| Q3 | 466476.5 |
| 95-th percentile | 683128.9 |
| Maximum | 999998 |
| Range | 999954 |
| Interquartile range (IQR) | 402704 |
Descriptive statistics
| Standard deviation | 224544.99 |
|---|---|
| Coefficient of variation (CV) | 0.79202102 |
| Kurtosis | -1.1815412 |
| Mean | 283508.88 |
| Median Absolute Deviation (MAD) | 192714 |
| Skewness | 0.4290238 |
| Sum | 4.6447259 × 109 |
| Variance | 5.0420452 × 1010 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 284 | 41 | 0.3% |
| 1141 | 14 | 0.1% |
| 300 | 13 | 0.1% |
| 580 | 12 | 0.1% |
| 9161 | 11 | 0.1% |
| 999998 | 10 | 0.1% |
| 9160 | 9 | 0.1% |
| 286 | 8 | < 0.1% |
| 297 | 8 | < 0.1% |
| 362720 | 7 | < 0.1% |
| Other values (15472) | 16250 |
| Value | Count | Frequency (%) |
| 44 | 2 | < 0.1% |
| 47 | 2 | < 0.1% |
| 49 | 2 | < 0.1% |
| 54 | 2 | < 0.1% |
| 55 | 2 | < 0.1% |
| 56 | 2 | < 0.1% |
| 60 | 2 | < 0.1% |
| 64 | 2 | < 0.1% |
| 65 | 1 | < 0.1% |
| 284 | 41 |
| Value | Count | Frequency (%) |
| 999998 | 10 | |
| 772033 | 1 | < 0.1% |
| 758020 | 1 | < 0.1% |
| 747661 | 1 | < 0.1% |
| 747631 | 1 | < 0.1% |
| 747584 | 1 | < 0.1% |
| 747570 | 1 | < 0.1% |
| 747558 | 1 | < 0.1% |
| 747526 | 1 | < 0.1% |
| 747525 | 1 | < 0.1% |
name
Text
| Distinct | 12988 |
|---|---|
| Distinct (%) | 79.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 128.1 KiB |
Length
| Max length | 30 |
|---|---|
| Median length | 25 |
| Mean length | 16.736983 |
| Min length | 3 |
Unique
| Unique | 10923 ? |
|---|---|
| Unique (%) | 66.7% |
Sample
| 1st row | DEEPAK DHAMI |
|---|---|
| 2nd row | UPENDRA P. SUBEDI |
| 3rd row | SIDDHI BHANDARI |
| 4th row | SHOBHA SHRESTHA |
| 5th row | APURVA RAUNIYAR |
| Value | Count | Frequency (%) |
| bahadur | 2533 | 5.8% |
| thapa | 1944 | 4.4% |
| maya | 1481 | 3.4% |
| shrestha | 1431 | 3.3% |
| gurung | 1105 | 2.5% |
| adhikari | 594 | 1.4% |
| kumari | 581 | 1.3% |
| kumar | 580 | 1.3% |
| ram | 548 | 1.3% |
| magar | 539 | 1.2% |
| Other values (4609) | 32393 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 56081 | |
| 27520 | 10.0% | |
| R | 21700 | 7.9% |
| H | 20428 | 7.4% |
| I | 16810 | 6.1% |
| N | 13380 | 4.9% |
| S | 12764 | 4.7% |
| U | 12614 | 4.6% |
| M | 11008 | 4.0% |
| T | 10701 | 3.9% |
| Other values (31) | 71196 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 274202 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 56081 | |
| 27520 | 10.0% | |
| R | 21700 | 7.9% |
| H | 20428 | 7.4% |
| I | 16810 | 6.1% |
| N | 13380 | 4.9% |
| S | 12764 | 4.7% |
| U | 12614 | 4.6% |
| M | 11008 | 4.0% |
| T | 10701 | 3.9% |
| Other values (31) | 71196 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 274202 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 56081 | |
| 27520 | 10.0% | |
| R | 21700 | 7.9% |
| H | 20428 | 7.4% |
| I | 16810 | 6.1% |
| N | 13380 | 4.9% |
| S | 12764 | 4.7% |
| U | 12614 | 4.6% |
| M | 11008 | 4.0% |
| T | 10701 | 3.9% |
| Other values (31) | 71196 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 274202 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 56081 | |
| 27520 | 10.0% | |
| R | 21700 | 7.9% |
| H | 20428 | 7.4% |
| I | 16810 | 6.1% |
| N | 13380 | 4.9% |
| S | 12764 | 4.7% |
| U | 12614 | 4.6% |
| M | 11008 | 4.0% |
| T | 10701 | 3.9% |
| Other values (31) | 71196 |
national
Categorical
High correlation Imbalance
| Distinct | 15 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 128.1 KiB |
| NP | |
|---|---|
| US | 14 |
| IN | 9 |
| B | 3 |
| SA | 3 |
| Other values (10) | 15 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 1.999939 |
| Min length | 1 |
Unique
| Unique | 7 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | NP |
|---|---|
| 2nd row | NP |
| 3rd row | NP |
| 4th row | NP |
| 5th row | NP |
Common Values
| Value | Count | Frequency (%) |
| NP | 16339 | |
| US | 14 | 0.1% |
| IN | 9 | 0.1% |
| B | 3 | < 0.1% |
| SA | 3 | < 0.1% |
| D | 3 | < 0.1% |
| T | 3 | < 0.1% |
| TA | 2 | < 0.1% |
| AT | 1 | < 0.1% |
| AU | 1 | < 0.1% |
| Other values (5) | 5 | < 0.1% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| np | 16339 | |
| us | 14 | 0.1% |
| in | 9 | 0.1% |
| b | 3 | < 0.1% |
| sa | 3 | < 0.1% |
| d | 3 | < 0.1% |
| t | 3 | < 0.1% |
| ta | 2 | < 0.1% |
| at | 1 | < 0.1% |
| au | 1 | < 0.1% |
| Other values (5) | 5 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 16348 | |
| P | 16339 | |
| S | 18 | 0.1% |
| U | 15 | < 0.1% |
| I | 10 | < 0.1% |
| 10 | < 0.1% | |
| A | 7 | < 0.1% |
| T | 6 | < 0.1% |
| D | 4 | < 0.1% |
| B | 3 | < 0.1% |
| Other values (4) | 5 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 32765 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| N | 16348 | |
| P | 16339 | |
| S | 18 | 0.1% |
| U | 15 | < 0.1% |
| I | 10 | < 0.1% |
| 10 | < 0.1% | |
| A | 7 | < 0.1% |
| T | 6 | < 0.1% |
| D | 4 | < 0.1% |
| B | 3 | < 0.1% |
| Other values (4) | 5 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 32765 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| N | 16348 | |
| P | 16339 | |
| S | 18 | 0.1% |
| U | 15 | < 0.1% |
| I | 10 | < 0.1% |
| 10 | < 0.1% | |
| A | 7 | < 0.1% |
| T | 6 | < 0.1% |
| D | 4 | < 0.1% |
| B | 3 | < 0.1% |
| Other values (4) | 5 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 32765 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| N | 16348 | |
| P | 16339 | |
| S | 18 | 0.1% |
| U | 15 | < 0.1% |
| I | 10 | < 0.1% |
| 10 | < 0.1% | |
| A | 7 | < 0.1% |
| T | 6 | < 0.1% |
| D | 4 | < 0.1% |
| B | 3 | < 0.1% |
| Other values (4) | 5 | < 0.1% |
resident
Categorical
High correlation Imbalance
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 128.1 KiB |
| NP | |
|---|---|
| US | 28 |
| IN | 5 |
| SA | 3 |
| NO | 3 |
| Other values (3) | 3 |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | NP |
|---|---|
| 2nd row | NP |
| 3rd row | NP |
| 4th row | NP |
| 5th row | NP |
Common Values
| Value | Count | Frequency (%) |
| NP | 16341 | |
| US | 28 | 0.2% |
| IN | 5 | < 0.1% |
| SA | 3 | < 0.1% |
| NO | 3 | < 0.1% |
| AT | 1 | < 0.1% |
| AU | 1 | < 0.1% |
| T | 1 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| np | 16341 | |
| us | 28 | 0.2% |
| in | 5 | < 0.1% |
| sa | 3 | < 0.1% |
| no | 3 | < 0.1% |
| at | 1 | < 0.1% |
| au | 1 | < 0.1% |
| t | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| N | 16349 | |
| P | 16341 | |
| S | 31 | 0.1% |
| U | 29 | 0.1% |
| I | 5 | < 0.1% |
| A | 5 | < 0.1% |
| O | 3 | < 0.1% |
| T | 2 | < 0.1% |
| 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 32766 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| N | 16349 | |
| P | 16341 | |
| S | 31 | 0.1% |
| U | 29 | 0.1% |
| I | 5 | < 0.1% |
| A | 5 | < 0.1% |
| O | 3 | < 0.1% |
| T | 2 | < 0.1% |
| 1 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 32766 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| N | 16349 | |
| P | 16341 | |
| S | 31 | 0.1% |
| U | 29 | 0.1% |
| I | 5 | < 0.1% |
| A | 5 | < 0.1% |
| O | 3 | < 0.1% |
| T | 2 | < 0.1% |
| 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 32766 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| N | 16349 | |
| P | 16341 | |
| S | 31 | 0.1% |
| U | 29 | 0.1% |
| I | 5 | < 0.1% |
| A | 5 | < 0.1% |
| O | 3 | < 0.1% |
| T | 2 | < 0.1% |
| 1 | < 0.1% |
industry
Text
| Distinct | 52 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 128.1 KiB |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 3.9980468 |
| Min length | 2 |
Unique
| Unique | 11 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | 9009 |
|---|---|
| 2nd row | 9009 |
| 3rd row | 9009 |
| 4th row | 9009 |
| 5th row | 9009 |
| Value | Count | Frequency (%) |
| 9008 | 14019 | |
| 9009 | 1656 | 10.1% |
| 9005 | 166 | 1.0% |
| 4005 | 111 | 0.7% |
| 9010 | 62 | 0.4% |
| 1230 | 54 | 0.3% |
| 4000 | 43 | 0.3% |
| 2010 | 42 | 0.3% |
| 4025 | 25 | 0.2% |
| 2005 | 24 | 0.1% |
| Other values (42) | 181 | 1.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 32610 | |
| 9 | 17589 | |
| 8 | 14026 | |
| 5 | 393 | 0.6% |
| 4 | 301 | 0.5% |
| 1 | 268 | 0.4% |
| 2 | 196 | 0.3% |
| 3 | 68 | 0.1% |
| N | 16 | < 0.1% |
| P | 16 | < 0.1% |
| Other values (2) | 17 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 65500 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 32610 | |
| 9 | 17589 | |
| 8 | 14026 | |
| 5 | 393 | 0.6% |
| 4 | 301 | 0.5% |
| 1 | 268 | 0.4% |
| 2 | 196 | 0.3% |
| 3 | 68 | 0.1% |
| N | 16 | < 0.1% |
| P | 16 | < 0.1% |
| Other values (2) | 17 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 65500 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 32610 | |
| 9 | 17589 | |
| 8 | 14026 | |
| 5 | 393 | 0.6% |
| 4 | 301 | 0.5% |
| 1 | 268 | 0.4% |
| 2 | 196 | 0.3% |
| 3 | 68 | 0.1% |
| N | 16 | < 0.1% |
| P | 16 | < 0.1% |
| Other values (2) | 17 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 65500 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 32610 | |
| 9 | 17589 | |
| 8 | 14026 | |
| 5 | 393 | 0.6% |
| 4 | 301 | 0.5% |
| 1 | 268 | 0.4% |
| 2 | 196 | 0.3% |
| 3 | 68 | 0.1% |
| N | 16 | < 0.1% |
| P | 16 | < 0.1% |
| Other values (2) | 17 | < 0.1% |
sector
Categorical
High correlation Imbalance
| Distinct | 23 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 128.1 KiB |
| 1500 | |
|---|---|
| 1000 | 130 |
| 1100 | 113 |
| 1450 | 93 |
| 1300 | 90 |
| Other values (18) | 283 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 3.9998779 |
| Min length | 2 |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 1500 |
|---|---|
| 2nd row | 1500 |
| 3rd row | 1500 |
| 4th row | 1500 |
| 5th row | 1500 |
Common Values
| Value | Count | Frequency (%) |
| 1500 | 15674 | |
| 1000 | 130 | 0.8% |
| 1100 | 113 | 0.7% |
| 1450 | 93 | 0.6% |
| 1300 | 90 | 0.5% |
| 9010 | 56 | 0.3% |
| 3000 | 42 | 0.3% |
| 1050 | 35 | 0.2% |
| 1550 | 35 | 0.2% |
| 1350 | 28 | 0.2% |
| Other values (13) | 87 | 0.5% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 1500 | 15674 | |
| 1000 | 130 | 0.8% |
| 1100 | 113 | 0.7% |
| 1450 | 93 | 0.6% |
| 1300 | 90 | 0.5% |
| 9010 | 56 | 0.3% |
| 3000 | 42 | 0.3% |
| 1050 | 35 | 0.2% |
| 1550 | 35 | 0.2% |
| 1350 | 28 | 0.2% |
| Other values (13) | 87 | 0.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 32764 | |
| 1 | 16402 | |
| 5 | 15944 | |
| 3 | 160 | 0.2% |
| 4 | 137 | 0.2% |
| 9 | 76 | 0.1% |
| 2 | 43 | 0.1% |
| 8 | 2 | < 0.1% |
| N | 1 | < 0.1% |
| P | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 65530 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 32764 | |
| 1 | 16402 | |
| 5 | 15944 | |
| 3 | 160 | 0.2% |
| 4 | 137 | 0.2% |
| 9 | 76 | 0.1% |
| 2 | 43 | 0.1% |
| 8 | 2 | < 0.1% |
| N | 1 | < 0.1% |
| P | 1 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 65530 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 32764 | |
| 1 | 16402 | |
| 5 | 15944 | |
| 3 | 160 | 0.2% |
| 4 | 137 | 0.2% |
| 9 | 76 | 0.1% |
| 2 | 43 | 0.1% |
| 8 | 2 | < 0.1% |
| N | 1 | < 0.1% |
| P | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 65530 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 32764 | |
| 1 | 16402 | |
| 5 | 15944 | |
| 3 | 160 | 0.2% |
| 4 | 137 | 0.2% |
| 9 | 76 | 0.1% |
| 2 | 43 | 0.1% |
| 8 | 2 | < 0.1% |
| N | 1 | < 0.1% |
| P | 1 | < 0.1% |
branch
Real number (ℝ)
High correlation
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.727278 |
| Minimum | 1 |
|---|---|
| Maximum | 90 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 128.1 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 12 |
| median | 12 |
| Q3 | 12 |
| 95-th percentile | 12 |
| Maximum | 90 |
| Range | 89 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 3.9721245 |
|---|---|
| Coefficient of variation (CV) | 0.3702826 |
| Kurtosis | 78.7952 |
| Mean | 10.727278 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 2.1603221 |
| Sum | 175745 |
| Variance | 15.777773 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) |
| 12 | 14414 | |
| 1 | 1953 | 11.9% |
| 90 | 8 | < 0.1% |
| 13 | 4 | < 0.1% |
| 11 | 2 | < 0.1% |
| 15 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 1953 | 11.9% |
| 11 | 2 | < 0.1% |
| 12 | 14414 | |
| 13 | 4 | < 0.1% |
| 15 | 2 | < 0.1% |
| 90 | 8 | < 0.1% |
| Value | Count | Frequency (%) |
| 90 | 8 | < 0.1% |
| 15 | 2 | < 0.1% |
| 13 | 4 | < 0.1% |
| 12 | 14414 | |
| 11 | 2 | < 0.1% |
| 1 | 1953 | 11.9% |
actype
Real number (ℝ)
| Distinct | 21 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 27.053287 |
| Minimum | 1 |
|---|---|
| Maximum | 99 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 128.1 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 22 |
| median | 22 |
| Q3 | 36 |
| 95-th percentile | 46 |
| Maximum | 99 |
| Range | 98 |
| Interquartile range (IQR) | 14 |
Descriptive statistics
| Standard deviation | 13.167484 |
|---|---|
| Coefficient of variation (CV) | 0.48672401 |
| Kurtosis | 8.9556915 |
| Mean | 27.053287 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.9084843 |
| Sum | 443214 |
| Variance | 173.38264 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=21)
| Value | Count | Frequency (%) |
| 22 | 6523 | |
| 23 | 2407 | 14.7% |
| 40 | 1967 | 12.0% |
| 36 | 1616 | 9.9% |
| 21 | 1199 | 7.3% |
| 1 | 871 | 5.3% |
| 46 | 685 | 4.2% |
| 18 | 449 | 2.7% |
| 99 | 191 | 1.2% |
| 45 | 138 | 0.8% |
| Other values (11) | 337 | 2.1% |
| Value | Count | Frequency (%) |
| 1 | 871 | 5.3% |
| 12 | 10 | 0.1% |
| 13 | 1 | < 0.1% |
| 18 | 449 | 2.7% |
| 21 | 1199 | 7.3% |
| 22 | 6523 | |
| 23 | 2407 | 14.7% |
| 24 | 34 | 0.2% |
| 36 | 1616 | 9.9% |
| 39 | 17 | 0.1% |
| Value | Count | Frequency (%) |
| 99 | 191 | 1.2% |
| 59 | 115 | 0.7% |
| 58 | 1 | < 0.1% |
| 57 | 37 | 0.2% |
| 54 | 7 | < 0.1% |
| 51 | 77 | 0.5% |
| 49 | 37 | 0.2% |
| 48 | 1 | < 0.1% |
| 46 | 685 | |
| 45 | 138 | 0.8% |
accountno
Text
| Distinct | 16302 |
|---|---|
| Distinct (%) | 99.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 128.1 KiB |
Length
| Max length | 12 |
|---|---|
| Median length | 12 |
| Mean length | 12 |
| Min length | 12 |
Unique
| Unique | 16248 ? |
|---|---|
| Unique (%) | 99.2% |
Sample
| 1st row | 012104445004 |
|---|---|
| 2nd row | 011801001998 |
| 3rd row | 019900670380 |
| 4th row | 012100674414 |
| 5th row | 012104442772 |
| Value | Count | Frequency (%) |
| 121 | 785 | 4.6% |
| 011 | 81 | 0.5% |
| 014500002842 | 8 | < 0.1% |
| 014500002843 | 7 | < 0.1% |
| 014500002849 | 6 | < 0.1% |
| 014500002841 | 4 | < 0.1% |
| 014500002840 | 4 | < 0.1% |
| 014500002846 | 3 | < 0.1% |
| 014500002972 | 3 | < 0.1% |
| 019909999984 | 3 | < 0.1% |
| Other values (16294) | 16345 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 42966 | |
| 0 | 36853 | |
| 1 | 30667 | |
| 3 | 15904 | 8.1% |
| 6 | 15104 | 7.7% |
| 4 | 14660 | 7.5% |
| 5 | 12984 | 6.6% |
| 8 | 10803 | 5.5% |
| 9 | 8081 | 4.1% |
| 7 | 7708 | 3.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 196596 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 2 | 42966 | |
| 0 | 36853 | |
| 1 | 30667 | |
| 3 | 15904 | 8.1% |
| 6 | 15104 | 7.7% |
| 4 | 14660 | 7.5% |
| 5 | 12984 | 6.6% |
| 8 | 10803 | 5.5% |
| 9 | 8081 | 4.1% |
| 7 | 7708 | 3.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 196596 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 2 | 42966 | |
| 0 | 36853 | |
| 1 | 30667 | |
| 3 | 15904 | 8.1% |
| 6 | 15104 | 7.7% |
| 4 | 14660 | 7.5% |
| 5 | 12984 | 6.6% |
| 8 | 10803 | 5.5% |
| 9 | 8081 | 4.1% |
| 7 | 7708 | 3.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 196596 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 2 | 42966 | |
| 0 | 36853 | |
| 1 | 30667 | |
| 3 | 15904 | 8.1% |
| 6 | 15104 | 7.7% |
| 4 | 14660 | 7.5% |
| 5 | 12984 | 6.6% |
| 8 | 10803 | 5.5% |
| 9 | 8081 | 4.1% |
| 7 | 7708 | 3.9% |
ccy
Categorical
High correlation Imbalance
| Distinct | 11 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 128.1 KiB |
| NPR | |
|---|---|
| USD | 45 |
| INR | 16 |
| 1.2 | 10 |
| EUR | 7 |
| Other values (6) | 17 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 2.9998779 |
| Min length | 1 |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | NPR |
|---|---|
| 2nd row | NPR |
| 3rd row | NPR |
| 4th row | NPR |
| 5th row | NPR |
Common Values
| Value | Count | Frequency (%) |
| NPR | 16288 | |
| USD | 45 | 0.3% |
| INR | 16 | 0.1% |
| 1.2 | 10 | 0.1% |
| EUR | 7 | < 0.1% |
| JPY | 6 | < 0.1% |
| 9.9 | 5 | < 0.1% |
| AUD | 2 | < 0.1% |
| GBP | 2 | < 0.1% |
| AED | 1 | < 0.1% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| npr | 16288 | |
| usd | 45 | 0.3% |
| inr | 16 | 0.1% |
| 1.2 | 10 | 0.1% |
| eur | 7 | < 0.1% |
| jpy | 6 | < 0.1% |
| 9.9 | 5 | < 0.1% |
| aud | 2 | < 0.1% |
| gbp | 2 | < 0.1% |
| aed | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| R | 16311 | |
| N | 16304 | |
| P | 16296 | |
| U | 54 | 0.1% |
| D | 48 | 0.1% |
| S | 45 | 0.1% |
| I | 16 | < 0.1% |
| . | 15 | < 0.1% |
| 1 | 11 | < 0.1% |
| 2 | 10 | < 0.1% |
| Other values (7) | 37 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 49147 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| R | 16311 | |
| N | 16304 | |
| P | 16296 | |
| U | 54 | 0.1% |
| D | 48 | 0.1% |
| S | 45 | 0.1% |
| I | 16 | < 0.1% |
| . | 15 | < 0.1% |
| 1 | 11 | < 0.1% |
| 2 | 10 | < 0.1% |
| Other values (7) | 37 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 49147 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| R | 16311 | |
| N | 16304 | |
| P | 16296 | |
| U | 54 | 0.1% |
| D | 48 | 0.1% |
| S | 45 | 0.1% |
| I | 16 | < 0.1% |
| . | 15 | < 0.1% |
| 1 | 11 | < 0.1% |
| 2 | 10 | < 0.1% |
| Other values (7) | 37 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 49147 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| R | 16311 | |
| N | 16304 | |
| P | 16296 | |
| U | 54 | 0.1% |
| D | 48 | 0.1% |
| S | 45 | 0.1% |
| I | 16 | < 0.1% |
| . | 15 | < 0.1% |
| 1 | 11 | < 0.1% |
| 2 | 10 | < 0.1% |
| Other values (7) | 37 | 0.1% |
category
Text
| Distinct | 53 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 128.1 KiB |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 3.9990844 |
| Min length | 3 |
Unique
| Unique | 8 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 6010 |
|---|---|
| 2nd row | 1018 |
| 3rd row | 4004 |
| 4th row | 6010 |
| 5th row | 6010 |
| Value | Count | Frequency (%) |
| 6007 | 3828 | |
| 6022 | 2405 | |
| 6023 | 1967 | |
| 6099 | 1950 | |
| 6019 | 1604 | |
| 6010 | 1199 | 7.3% |
| 6024 | 686 | 4.2% |
| 6001 | 644 | 3.9% |
| 1018 | 449 | 2.7% |
| 1013 | 278 | 1.7% |
| Other values (43) | 1373 | 8.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 23022 | |
| 6 | 14738 | |
| 2 | 7707 | 11.8% |
| 1 | 6213 | 9.5% |
| 9 | 5511 | 8.4% |
| 7 | 3846 | 5.9% |
| 3 | 2527 | 3.9% |
| 4 | 1074 | 1.6% |
| 8 | 473 | 0.7% |
| 5 | 360 | 0.5% |
| Other values (4) | 46 | 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 65517 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 23022 | |
| 6 | 14738 | |
| 2 | 7707 | 11.8% |
| 1 | 6213 | 9.5% |
| 9 | 5511 | 8.4% |
| 7 | 3846 | 5.9% |
| 3 | 2527 | 3.9% |
| 4 | 1074 | 1.6% |
| 8 | 473 | 0.7% |
| 5 | 360 | 0.5% |
| Other values (4) | 46 | 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 65517 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 23022 | |
| 6 | 14738 | |
| 2 | 7707 | 11.8% |
| 1 | 6213 | 9.5% |
| 9 | 5511 | 8.4% |
| 7 | 3846 | 5.9% |
| 3 | 2527 | 3.9% |
| 4 | 1074 | 1.6% |
| 8 | 473 | 0.7% |
| 5 | 360 | 0.5% |
| Other values (4) | 46 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 65517 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 23022 | |
| 6 | 14738 | |
| 2 | 7707 | 11.8% |
| 1 | 6213 | 9.5% |
| 9 | 5511 | 8.4% |
| 7 | 3846 | 5.9% |
| 3 | 2527 | 3.9% |
| 4 | 1074 | 1.6% |
| 8 | 473 | 0.7% |
| 5 | 360 | 0.5% |
| Other values (4) | 46 | 0.1% |
acbal
Real number (ℝ)
High correlation Skewed Zeros
| Distinct | 14536 |
|---|---|
| Distinct (%) | 88.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -123301.22 |
| Minimum | -2.4845915 × 109 |
|---|---|
| Maximum | 6.8659289 × 108 |
| Zeros | 732 |
| Zeros (%) | 4.5% |
| Negative | 1282 |
| Negative (%) | 7.8% |
| Memory size | 128.1 KiB |
Quantile statistics
| Minimum | -2.4845915 × 109 |
|---|---|
| 5-th percentile | -25370.739 |
| Q1 | 159.99 |
| median | 1146.14 |
| Q3 | 11029 |
| 95-th percentile | 186563.21 |
| Maximum | 6.8659289 × 108 |
| Range | 3.1711844 × 109 |
| Interquartile range (IQR) | 10869.01 |
Descriptive statistics
| Standard deviation | 20782781 |
|---|---|
| Coefficient of variation (CV) | -168.55291 |
| Kurtosis | 12560.616 |
| Mean | -123301.22 |
| Median Absolute Deviation (MAD) | 1146.14 |
| Skewness | -101.63013 |
| Sum | -2.020044 × 109 |
| Variance | 4.3192398 × 1014 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 732 | 4.5% |
| 7500 | 92 | 0.6% |
| 10.95 | 82 | 0.5% |
| 6.89 | 47 | 0.3% |
| 5.51 | 43 | 0.3% |
| 111.34 | 28 | 0.2% |
| 52761.93 | 23 | 0.1% |
| 556.85 | 21 | 0.1% |
| 16.48 | 20 | 0.1% |
| 100 | 20 | 0.1% |
| Other values (14526) | 15275 |
| Value | Count | Frequency (%) |
| -2484591470 | 1 | |
| -298976044 | 1 | |
| -153486495 | 1 | |
| -140755542.2 | 1 | |
| -126150923.1 | 1 | |
| -105162699.3 | 1 | |
| -88809883.19 | 1 | |
| -72140776.43 | 1 | |
| -71093375.91 | 1 | |
| -66022133.42 | 1 |
| Value | Count | Frequency (%) |
| 686592892.6 | 1 | |
| 473256847.6 | 1 | |
| 50781069.48 | 1 | |
| 50000763.53 | 1 | |
| 47113884.23 | 1 | |
| 46900376 | 1 | |
| 43494059.78 | 1 | |
| 33598138.54 | 1 | |
| 26700938.59 | 1 | |
| 21445443.53 | 1 |
lcyacbal
Real number (ℝ)
High correlation Skewed Zeros
| Distinct | 14546 |
|---|---|
| Distinct (%) | 88.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -326524.51 |
| Minimum | -2.4845915 × 109 |
|---|---|
| Maximum | 6.8659289 × 108 |
| Zeros | 746 |
| Zeros (%) | 4.6% |
| Negative | 1280 |
| Negative (%) | 7.8% |
| Memory size | 128.1 KiB |
Quantile statistics
| Minimum | -2.4845915 × 109 |
|---|---|
| 5-th percentile | -26104.207 |
| Q1 | 159.035 |
| median | 1144.2 |
| Q3 | 11050.005 |
| 95-th percentile | 192535.97 |
| Maximum | 6.8659289 × 108 |
| Range | 3.1711844 × 109 |
| Interquartile range (IQR) | 10890.97 |
Descriptive statistics
| Standard deviation | 24303663 |
|---|---|
| Coefficient of variation (CV) | -74.43136 |
| Kurtosis | 7209.7954 |
| Mean | -326524.51 |
| Median Absolute Deviation (MAD) | 1144.2 |
| Skewness | -74.456591 |
| Sum | -5.3494511 × 109 |
| Variance | 5.9066806 × 1014 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 746 | 4.6% |
| 7500 | 93 | 0.6% |
| 10.95 | 82 | 0.5% |
| 6.89 | 47 | 0.3% |
| 5.51 | 43 | 0.3% |
| 111.34 | 28 | 0.2% |
| 52761.93 | 23 | 0.1% |
| 556.85 | 21 | 0.1% |
| 16.48 | 20 | 0.1% |
| 100 | 20 | 0.1% |
| Other values (14536) | 15260 |
| Value | Count | Frequency (%) |
| -2484591470 | 1 | |
| -1249626339 | 1 | |
| -747305056.3 | 1 | |
| -497626940.2 | 1 | |
| -413825369.5 | 1 | |
| -298976044 | 1 | |
| -154492209.2 | 1 | |
| -152361554.9 | 1 | |
| -150943204.9 | 1 | |
| -140755542.2 | 1 |
| Value | Count | Frequency (%) |
| 686592892.6 | 1 | |
| 473256847.6 | 1 | |
| 50781069.48 | 1 | |
| 50000763.53 | 1 | |
| 47113884.23 | 1 | |
| 46900376 | 1 | |
| 43494059.78 | 1 | |
| 33598138.54 | 1 | |
| 28894633.59 | 1 | |
| 26700938.59 | 1 |
| Value | Count | Frequency (%) |
| False | 10634 | |
| True | 5749 |
ibservice
Boolean
High correlation Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 16.1 KiB |
| False | |
|---|---|
| True | 1168 |
| Value | Count | Frequency (%) |
| False | 15215 | |
| True | 1168 | 7.1% |
| Value | Count | Frequency (%) |
| False | 11122 | |
| True | 5261 |
kyc
Boolean
Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 16.1 KiB |
| True | |
|---|---|
| False | 1195 |
| Value | Count | Frequency (%) |
| True | 15188 | |
| False | 1195 | 7.3% |
| Value | Count | Frequency (%) |
| False | 10248 | |
| True | 6135 |
mobileno
Text
| Distinct | 13209 |
|---|---|
| Distinct (%) | 81.1% |
| Missing | 103 |
| Missing (%) | 0.6% |
| Memory size | 128.1 KiB |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 9.4398649 |
| Min length | 1 |
Unique
| Unique | 11316 ? |
|---|---|
| Unique (%) | 69.5% |
Sample
| 1st row | 9848627268 |
|---|---|
| 2nd row | 9841464720 |
| 3rd row | 9841369614 |
| 4th row | 9856041044 |
| 5th row | 9823452053 |
| Value | Count | Frequency (%) |
| 20171022 | 43 | 0.3% |
| 9.78e+12 | 35 | 0.2% |
| 20091206 | 33 | 0.2% |
| 20170908 | 32 | 0.2% |
| 20170727 | 32 | 0.2% |
| 20171210 | 23 | 0.1% |
| 20100412 | 21 | 0.1% |
| 20171023 | 20 | 0.1% |
| 20091203 | 17 | 0.1% |
| 20190428 | 13 | 0.1% |
| Other values (13197) | 16011 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 23193 | |
| 9 | 19663 | |
| 8 | 19426 | |
| 1 | 19077 | |
| 2 | 15438 | |
| 4 | 15039 | |
| 6 | 14888 | |
| 5 | 9381 | |
| 3 | 8654 | 5.6% |
| 7 | 8394 | 5.5% |
| Other values (20) | 528 | 0.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 153681 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 23193 | |
| 9 | 19663 | |
| 8 | 19426 | |
| 1 | 19077 | |
| 2 | 15438 | |
| 4 | 15039 | |
| 6 | 14888 | |
| 5 | 9381 | |
| 3 | 8654 | 5.6% |
| 7 | 8394 | 5.5% |
| Other values (20) | 528 | 0.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 153681 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 23193 | |
| 9 | 19663 | |
| 8 | 19426 | |
| 1 | 19077 | |
| 2 | 15438 | |
| 4 | 15039 | |
| 6 | 14888 | |
| 5 | 9381 | |
| 3 | 8654 | 5.6% |
| 7 | 8394 | 5.5% |
| Other values (20) | 528 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 153681 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 23193 | |
| 9 | 19663 | |
| 8 | 19426 | |
| 1 | 19077 | |
| 2 | 15438 | |
| 4 | 15039 | |
| 6 | 14888 | |
| 5 | 9381 | |
| 3 | 8654 | 5.6% |
| 7 | 8394 | 5.5% |
| Other values (20) | 528 | 0.3% |
opendate
Text
| Distinct | 4020 |
|---|---|
| Distinct (%) | 24.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 128.1 KiB |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 8.9468962 |
| Min length | 7 |
Unique
| Unique | 1026 ? |
|---|---|
| Unique (%) | 6.3% |
Sample
| 1st row | 01-Jul-18 |
|---|---|
| 2nd row | 13-Sep-17 |
| 3rd row | 08-Jul-10 |
| 4th row | 02-Mar-08 |
| 5th row | 25-Sep-17 |
| Value | Count | Frequency (%) |
| 870 | 5.2% | |
| 22-oct-17 | 467 | 2.8% |
| 16-nov-17 | 443 | 2.6% |
| 08-sep-17 | 430 | 2.6% |
| 27-jul-17 | 243 | 1.4% |
| 23-oct-17 | 222 | 1.3% |
| 10-dec-17 | 162 | 1.0% |
| 12-nov-17 | 139 | 0.8% |
| 03-aug-12 | 93 | 0.6% |
| 06-dec-09 | 64 | 0.4% |
| Other values (4010) | 13685 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 32766 | |
| 1 | 19936 | |
| 0 | 10902 | 7.4% |
| 2 | 8739 | 6.0% |
| 7 | 5438 | 3.7% |
| e | 4131 | 2.8% |
| 8 | 3965 | 2.7% |
| J | 3734 | 2.5% |
| a | 3634 | 2.5% |
| u | 3612 | 2.5% |
| Other values (24) | 49720 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 146577 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| - | 32766 | |
| 1 | 19936 | |
| 0 | 10902 | 7.4% |
| 2 | 8739 | 6.0% |
| 7 | 5438 | 3.7% |
| e | 4131 | 2.8% |
| 8 | 3965 | 2.7% |
| J | 3734 | 2.5% |
| a | 3634 | 2.5% |
| u | 3612 | 2.5% |
| Other values (24) | 49720 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 146577 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| - | 32766 | |
| 1 | 19936 | |
| 0 | 10902 | 7.4% |
| 2 | 8739 | 6.0% |
| 7 | 5438 | 3.7% |
| e | 4131 | 2.8% |
| 8 | 3965 | 2.7% |
| J | 3734 | 2.5% |
| a | 3634 | 2.5% |
| u | 3612 | 2.5% |
| Other values (24) | 49720 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 146577 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| - | 32766 | |
| 1 | 19936 | |
| 0 | 10902 | 7.4% |
| 2 | 8739 | 6.0% |
| 7 | 5438 | 3.7% |
| e | 4131 | 2.8% |
| 8 | 3965 | 2.7% |
| J | 3734 | 2.5% |
| a | 3634 | 2.5% |
| u | 3612 | 2.5% |
| Other values (24) | 49720 |
ldrdate
Text
| Distinct | 3781 |
|---|---|
| Distinct (%) | 23.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 128.1 KiB |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 8.9106391 |
| Min length | 7 |
Unique
| Unique | 1924 ? |
|---|---|
| Unique (%) | 11.7% |
Sample
| 1st row | 05-Jan-25 |
|---|---|
| 2nd row | 10-Jan-25 |
| 3rd row | 08-Jul-10 |
| 4th row | 24-Apr-19 |
| 5th row | 03-Jan-25 |
| Value | Count | Frequency (%) |
| 1464 | 8.6% | |
| 02-jan-25 | 384 | 2.2% |
| 28-apr-19 | 311 | 1.8% |
| 11-jan-25 | 293 | 1.7% |
| 03-jan-25 | 205 | 1.2% |
| 26-apr-19 | 204 | 1.2% |
| 10-jan-25 | 190 | 1.1% |
| 24-dec-17 | 177 | 1.0% |
| 29-apr-19 | 176 | 1.0% |
| 04-jan-25 | 151 | 0.9% |
| Other values (3771) | 13560 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 32766 | |
| 1 | 19532 | |
| 2 | 9453 | 6.5% |
| 0 | 7490 | 5.1% |
| 9 | 5984 | 4.1% |
| a | 5118 | 3.5% |
| r | 4568 | 3.1% |
| J | 4504 | 3.1% |
| 8 | 4358 | 3.0% |
| 5 | 4291 | 2.9% |
| Other values (24) | 47919 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 145983 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| - | 32766 | |
| 1 | 19532 | |
| 2 | 9453 | 6.5% |
| 0 | 7490 | 5.1% |
| 9 | 5984 | 4.1% |
| a | 5118 | 3.5% |
| r | 4568 | 3.1% |
| J | 4504 | 3.1% |
| 8 | 4358 | 3.0% |
| 5 | 4291 | 2.9% |
| Other values (24) | 47919 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 145983 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| - | 32766 | |
| 1 | 19532 | |
| 2 | 9453 | 6.5% |
| 0 | 7490 | 5.1% |
| 9 | 5984 | 4.1% |
| a | 5118 | 3.5% |
| r | 4568 | 3.1% |
| J | 4504 | 3.1% |
| 8 | 4358 | 3.0% |
| 5 | 4291 | 2.9% |
| Other values (24) | 47919 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 145983 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| - | 32766 | |
| 1 | 19532 | |
| 2 | 9453 | 6.5% |
| 0 | 7490 | 5.1% |
| 9 | 5984 | 4.1% |
| a | 5118 | 3.5% |
| r | 4568 | 3.1% |
| J | 4504 | 3.1% |
| 8 | 4358 | 3.0% |
| 5 | 4291 | 2.9% |
| Other values (24) | 47919 |
lcrdate
Text
| Distinct | 5285 |
|---|---|
| Distinct (%) | 32.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 128.1 KiB |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 8.709577 |
| Min length | 7 |
Unique
| Unique | 3562 ? |
|---|---|
| Unique (%) | 21.7% |
Sample
| 1st row | 02-Jan-25 |
|---|---|
| 2nd row | 16-Apr-19 |
| 3rd row | 08-Jul-10 |
| 4th row | 11-Jan-25 |
| 5th row | 05-Jan-25 |
| Value | Count | Frequency (%) |
| 4758 | 25.4% | |
| 02-jan-25 | 675 | 3.6% |
| 06-jan-25 | 240 | 1.3% |
| 11-jan-25 | 211 | 1.1% |
| 10-jan-25 | 199 | 1.1% |
| 28-apr-19 | 151 | 0.8% |
| 04-jan-25 | 144 | 0.8% |
| 09-jan-25 | 143 | 0.8% |
| 05-jan-25 | 127 | 0.7% |
| 26-dec-24 | 120 | 0.6% |
| Other values (5275) | 11994 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 32766 | |
| 1 | 15020 | 10.5% |
| 11895 | 8.3% | |
| 2 | 9168 | 6.4% |
| 0 | 7424 | 5.2% |
| a | 5206 | 3.6% |
| 5 | 4993 | 3.5% |
| 9 | 4624 | 3.2% |
| J | 4487 | 3.1% |
| r | 3860 | 2.7% |
| Other values (24) | 43246 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 142689 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| - | 32766 | |
| 1 | 15020 | 10.5% |
| 11895 | 8.3% | |
| 2 | 9168 | 6.4% |
| 0 | 7424 | 5.2% |
| a | 5206 | 3.6% |
| 5 | 4993 | 3.5% |
| 9 | 4624 | 3.2% |
| J | 4487 | 3.1% |
| r | 3860 | 2.7% |
| Other values (24) | 43246 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 142689 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| - | 32766 | |
| 1 | 15020 | 10.5% |
| 11895 | 8.3% | |
| 2 | 9168 | 6.4% |
| 0 | 7424 | 5.2% |
| a | 5206 | 3.6% |
| 5 | 4993 | 3.5% |
| 9 | 4624 | 3.2% |
| J | 4487 | 3.1% |
| r | 3860 | 2.7% |
| Other values (24) | 43246 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 142689 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| - | 32766 | |
| 1 | 15020 | 10.5% |
| 11895 | 8.3% | |
| 2 | 9168 | 6.4% |
| 0 | 7424 | 5.2% |
| a | 5206 | 3.6% |
| 5 | 4993 | 3.5% |
| 9 | 4624 | 3.2% |
| J | 4487 | 3.1% |
| r | 3860 | 2.7% |
| Other values (24) | 43246 |
dob
Text
| Distinct | 6282 |
|---|---|
| Distinct (%) | 38.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 128.1 KiB |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 8.087835 |
| Min length | 7 |
Unique
| Unique | 4422 ? |
|---|---|
| Unique (%) | 27.0% |
Sample
| 1st row | 03-Apr-52 |
|---|---|
| 2nd row | 14-Jul-42 |
| 3rd row | 15-Sep-35 |
| 4th row | 29-Jan-36 |
| 5th row | 12-Nov-50 |
| Value | Count | Frequency (%) |
| 14944 | ||
| 01-jan-45 | 9 | < 0.1% |
| 15-jun-38 | 7 | < 0.1% |
| 01-jan-16 | 7 | < 0.1% |
| 15-aug-36 | 7 | < 0.1% |
| 01-jan-14 | 7 | < 0.1% |
| 15-aug-38 | 6 | < 0.1% |
| 28-apr-44 | 6 | < 0.1% |
| 01-jan-49 | 6 | < 0.1% |
| 10-oct-49 | 6 | < 0.1% |
| Other values (6272) | 8850 |
Most occurring characters
| Value | Count | Frequency (%) |
| 37360 | ||
| - | 32766 | |
| 1 | 6174 | 4.7% |
| 2 | 5559 | 4.2% |
| 0 | 5031 | 3.8% |
| 4 | 4504 | 3.4% |
| 3 | 4034 | 3.0% |
| 5 | 3423 | 2.6% |
| a | 2631 | 2.0% |
| J | 2373 | 1.8% |
| Other values (24) | 28648 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 132503 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 37360 | ||
| - | 32766 | |
| 1 | 6174 | 4.7% |
| 2 | 5559 | 4.2% |
| 0 | 5031 | 3.8% |
| 4 | 4504 | 3.4% |
| 3 | 4034 | 3.0% |
| 5 | 3423 | 2.6% |
| a | 2631 | 2.0% |
| J | 2373 | 1.8% |
| Other values (24) | 28648 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 132503 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 37360 | ||
| - | 32766 | |
| 1 | 6174 | 4.7% |
| 2 | 5559 | 4.2% |
| 0 | 5031 | 3.8% |
| 4 | 4504 | 3.4% |
| 3 | 4034 | 3.0% |
| 5 | 3423 | 2.6% |
| a | 2631 | 2.0% |
| J | 2373 | 1.8% |
| Other values (24) | 28648 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 132503 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 37360 | ||
| - | 32766 | |
| 1 | 6174 | 4.7% |
| 2 | 5559 | 4.2% |
| 0 | 5031 | 3.8% |
| 4 | 4504 | 3.4% |
| 3 | 4034 | 3.0% |
| 5 | 3423 | 2.6% |
| a | 2631 | 2.0% |
| J | 2373 | 1.8% |
| Other values (24) | 28648 |
Interactions
Correlations
| acbal | acservice | actype | branch | ccy | custid | ibservice | inactive | kyc | lcyacbal | mbservice | national | resident | sector | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| acbal | 1.000 | 0.000 | 0.091 | 0.024 | 0.000 | -0.111 | 0.000 | 0.000 | 0.037 | 0.997 | 0.000 | 0.000 | 0.000 | 0.133 |
| acservice | 0.000 | 1.000 | 0.223 | 0.339 | 0.011 | 0.371 | 0.278 | 0.014 | 0.106 | 0.000 | 0.448 | 0.027 | 0.011 | 0.094 |
| actype | 0.091 | 0.223 | 1.000 | 0.394 | 0.124 | -0.106 | 0.218 | 0.132 | 0.166 | 0.090 | 0.256 | 0.087 | 0.080 | 0.344 |
| branch | 0.024 | 0.339 | 0.394 | 1.000 | 0.541 | -0.017 | 0.583 | 0.246 | 0.089 | 0.026 | 0.382 | 0.680 | 0.264 | 0.600 |
| ccy | 0.000 | 0.011 | 0.124 | 0.541 | 1.000 | 0.044 | 0.000 | 0.045 | 0.203 | 0.208 | 0.047 | 0.572 | 0.559 | 0.622 |
| custid | -0.111 | 0.371 | -0.106 | -0.017 | 0.044 | 1.000 | 0.402 | 0.262 | 0.198 | -0.109 | 0.319 | 0.009 | 0.018 | 0.359 |
| ibservice | 0.000 | 0.278 | 0.218 | 0.583 | 0.000 | 0.402 | 1.000 | 0.196 | 0.060 | 0.000 | 0.317 | 0.000 | 0.000 | 0.030 |
| inactive | 0.000 | 0.014 | 0.132 | 0.246 | 0.045 | 0.262 | 0.196 | 1.000 | 0.178 | 0.000 | 0.162 | 0.028 | 0.030 | 0.085 |
| kyc | 0.037 | 0.106 | 0.166 | 0.089 | 0.203 | 0.198 | 0.060 | 0.178 | 1.000 | 0.066 | 0.040 | 0.160 | 0.154 | 0.336 |
| lcyacbal | 0.997 | 0.000 | 0.090 | 0.026 | 0.208 | -0.109 | 0.000 | 0.000 | 0.066 | 1.000 | 0.000 | 0.257 | 0.275 | 0.158 |
| mbservice | 0.000 | 0.448 | 0.256 | 0.382 | 0.047 | 0.319 | 0.317 | 0.162 | 0.040 | 0.000 | 1.000 | 0.018 | 0.028 | 0.124 |
| national | 0.000 | 0.027 | 0.087 | 0.680 | 0.572 | 0.009 | 0.000 | 0.028 | 0.160 | 0.257 | 0.018 | 1.000 | 0.791 | 0.631 |
| resident | 0.000 | 0.011 | 0.080 | 0.264 | 0.559 | 0.018 | 0.000 | 0.030 | 0.154 | 0.275 | 0.028 | 0.791 | 1.000 | 0.676 |
| sector | 0.133 | 0.094 | 0.344 | 0.600 | 0.622 | 0.359 | 0.030 | 0.085 | 0.336 | 0.158 | 0.124 | 0.631 | 0.676 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
Sample
| custid | name | national | resident | industry | sector | branch | actype | accountno | ccy | category | acbal | lcyacbal | mbservice | ibservice | acservice | kyc | inactive | mobileno | opendate | ldrdate | lcrdate | dob | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 444500 | DEEPAK DHAMI | NP | NP | 9009 | 1500 | 1 | 21 | 012104445004 | NPR | 6010 | 142204.69 | 142204.69 | True | True | True | True | False | 9848627268 | 01-Jul-18 | 05-Jan-25 | 02-Jan-25 | 03-Apr-52 |
| 1 | 100199 | UPENDRA P. SUBEDI | NP | NP | 9009 | 1500 | 1 | 18 | 011801001998 | NPR | 1018 | -28299.21 | -28299.21 | True | True | True | True | False | 9841464720 | 13-Sep-17 | 10-Jan-25 | 16-Apr-19 | 14-Jul-42 |
| 2 | 67038 | SIDDHI BHANDARI | NP | NP | 9009 | 1500 | 1 | 99 | 019900670380 | NPR | 4004 | 0.00 | 0.00 | True | True | False | True | True | 9841369614 | 08-Jul-10 | 08-Jul-10 | 08-Jul-10 | 15-Sep-35 |
| 3 | 67441 | SHOBHA SHRESTHA | NP | NP | 9009 | 1500 | 1 | 21 | 012100674414 | NPR | 6010 | 18971.88 | 18971.88 | True | False | False | True | False | 9856041044 | 02-Mar-08 | 24-Apr-19 | 11-Jan-25 | 29-Jan-36 |
| 4 | 444277 | APURVA RAUNIYAR | NP | NP | 9009 | 1500 | 1 | 21 | 012104442772 | NPR | 6010 | 26203.03 | 26203.03 | True | True | True | True | False | 9823452053 | 25-Sep-17 | 03-Jan-25 | 05-Jan-25 | 12-Nov-50 |
| 5 | 403653 | DIBYA RAJ POKHAREL | NP | NP | 9009 | 1500 | 1 | 21 | 012104036537 | NPR | 6010 | 2817.88 | 2817.88 | True | False | True | True | False | 9842072607 | 03-Aug-12 | 02-Jan-25 | 28-Apr-19 | 28-Sep-37 |
| 6 | 164201 | BIKRAM PRAJAPATI | NP | NP | 9009 | 1500 | 1 | 18 | 011801642016 | NPR | 1018 | -300000.00 | -300000.00 | True | False | True | True | False | 9841745446 | 17-Oct-17 | 19-Dec-18 | 01-Feb-18 | 05-Oct-45 |
| 7 | 444370 | BISHAL KHANAL | NP | NP | 9009 | 1500 | 1 | 21 | 012104443702 | NPR | 6010 | 28696.85 | 28696.85 | True | True | True | True | False | 9845212172 | 14-Feb-18 | 25-Apr-19 | 25-Mar-19 | 11-Nov-46 |
| 8 | 683010 | SAROJ JAIRU | NP | NP | 9009 | 1500 | 1 | 21 | 012106830108 | NPR | 6010 | -4485.82 | -4485.82 | True | True | True | True | False | 9816349098 | 08-Jul-18 | 10-Jan-25 | 26-Dec-24 | 17-Jul-49 |
| 9 | 683204 | GIRWAN BIKRAM THAPA | NP | NP | 9009 | 1500 | 1 | 21 | 012106832045 | NPR | 6010 | -6999.58 | -6999.58 | True | True | True | True | False | 9802005050 | 05-Mar-19 | 08-Jan-25 | 25-Apr-19 | 07-May-49 |
| custid | name | national | resident | industry | sector | branch | actype | accountno | ccy | category | acbal | lcyacbal | mbservice | ibservice | acservice | kyc | inactive | mobileno | opendate | ldrdate | lcrdate | dob | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16373 | 152857 | SHIVA LAL DARAI | NP | NP | 9008 | 1500 | 12 | 22 | 122201528574 | NPR | 6007 | 507248.92 | 507248.92 | False | False | False | True | False | 9805800855 | 18-Nov-09 | 21-Feb-19 | 02-Dec-18 | 13-Aug-17 |
| 16374 | 63958 | MAHESH GAUTAM | NP | NP | 9008 | 1500 | 12 | 40 | 124000639589 | NPR | 6023 | 8541.05 | 8541.05 | False | False | False | True | False | 20080907 | 10-Sep-09 | 01-Sep-09 | 16-Jan-40 | - - |
| 16375 | 242543 | BHAGAWATI THAPA CHHETRI | NP | NP | 9008 | 1500 | 12 | 23 | 122302425435 | NPR | 6022 | 407.10 | 407.10 | False | False | True | False | True | 9846131391 | 05-Mar-12 | 05-Mar-12 | 15-Feb-39 | - - |
| 16376 | 242627 | AMBI MAYA THAPA | NP | NP | 9008 | 1500 | 12 | 23 | 122302426272 | NPR | 6022 | 105923.87 | 105923.87 | False | False | True | True | False | 9846497455 | 25-Mar-12 | 10-Mar-19 | 28-Apr-19 | 04-Oct-45 |
| 16377 | 465390 | ASMITA THAPA MAGAR | NP | NP | 9008 | 1500 | 12 | 36 | 123604653900 | NPR | 6019 | 5821.03 | 5821.03 | False | False | False | True | True | 9808868553 | 06-Mar-16 | 24-Oct-16 | 26-Sep-16 | 23-Feb-52 |
| 16378 | 302556 | GYAN BAHADUR B.K. | NP | NP | 9008 | 1500 | 12 | 22 | 122203025569 | NPR | 6007 | 180.99 | 180.99 | True | False | False | True | True | 9818366779 | 05-Feb-14 | 12-Mar-18 | 29-Feb-16 | 14-Nov-43 |
| 16379 | 182742 | DOL RAJ REGMI | NP | NP | 9008 | 1500 | 12 | 36 | 123601827422 | NPR | 6019 | 1570.05 | 1570.05 | True | False | True | True | False | 9856080844 | 20-Aug-10 | 07-Apr-19 | 12-Mar-19 | 01-Nov-24 |
| 16380 | 182566 | MOTISARA KUMAL | NP | NP | 9008 | 1500 | 12 | 23 | 122301825665 | NPR | 6022 | 873.69 | 873.69 | False | False | False | True | False | 20100728 | 03-Aug-11 | 06-Sep-10 | 13-May-40 | - - |
| 16381 | 301354 | SHREE NARAYAN DATTA SIGDEL | NP | NP | 9008 | 1500 | 12 | 46 | 124603013545 | NPR | 6024 | 352.73 | 352.73 | True | False | False | True | True | 9860233519 | 30-Apr-13 | 09-Feb-17 | 11-Sep-16 | 18-Dec-19 |
| 16382 | 357989 | UMESH KUMAR MANDAL | NP | NP | 9008 | 1500 | 12 | 36 | 123603579899 | NPR | 6019 | 100.06 | 100.06 | True | False | True | True | False | 9844408236 | 05-Feb-15 | 21-Apr-19 | 21-Apr-19 | 15-Nov-47 |
Duplicate rows
Most frequently occurring
| custid | name | national | resident | industry | sector | branch | actype | accountno | ccy | category | acbal | lcyacbal | mbservice | ibservice | acservice | kyc | inactive | mobileno | opendate | ldrdate | lcrdate | dob | # duplicates | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 284 | NEPAL RASTRA BANK | NP | NP | 4000 | 3000 | 1 | 45 | 014500002842 | USD | 5001 | 0.0 | 0.0 | False | False | True | False | False | NaN | - - | - - | - - | - - | 2 |